package ledrpt

import org.kdx.DateUtils

import java.text.SimpleDateFormat

class EqpOeeController {
    def dynamicQueryService
    def eqpOee() {
        SimpleDateFormat sdf = new SimpleDateFormat('yyyy-MM-dd HH')
        def startTime = params.startTime ? sdf.parse(params.startTime) : sdf.parse(sdf.format(new Date().clearTime()-30))
        def endTime = params.endTime ? sdf.parse(params.endTime) : sdf.parse(sdf.format(new Date()))
        params.startTime = sdf.format(startTime)
        params.endTime = sdf.format(endTime)
        def dayList = DateUtils.getHourList(startTime, endTime)
        params.SYS_QUERY_NAME='eqpOee'
        def eqpOeeList =dynamicQueryService.queryForList(params)
        def legendDataList = ['QTY','YIELD',]
        def percentItemList = ['YIELD']
        def seriesData = [[85, 90],[85, 90]]
        def pageSizeList = [10, 20, 50, 100]
        def totalCount=5
        def pageCurrent = params.pageCurrent ? Integer.parseInt(params.pageCurrent) : 1
        def pageSize = params.pageSize ? Integer.parseInt(params.pageSize) : 10
        params.startno = (pageSize * (pageCurrent - 1)) + 1
        params.endno = pageSize * pageCurrent










        [startTime:startTime,endTime:endTime,productid:params.productid?:'',pageSizeList:pageSizeList,totalCount:totalCount,pageCurrent:pageCurrent,pageSize:pageSize,
         dayList:dayList,legendDataList:legendDataList,seriesData:seriesData,percentItemList:percentItemList,eqpOeeList:eqpOeeList
        ]
    }
    def exportExcel() {


        def dataList = []

        def tableHeadList =  []
        params.SYS_QUERY_NAME='eqpOee'
        def eqpOeeList =dynamicQueryService.queryForList(params)
        String filename = new String("OEEExcel.xls".getBytes("UTF-8"), "UTF-8");
        response.setContentType('application/vnd.ms-excel;charset=UTF-8')
        response.setHeader('Content-disposition', "attachment;filename=${filename};charset=UTF-8")
        response.setCharacterEncoding("UTF-8");
        render(template: "exportExcel", model: [dataList: dataList,tableHeadList:tableHeadList,eqpOeeList:eqpOeeList])
    }
}
